Devin Lee
Devin Lee
Reactions
-
Re: CountIf with Multiple Criteria + Mutli-Sheet Reference
Just missing the "S" on COUNTIFS =COUNTIFS(PRIORITY:PRIORITY, "Medium", STATUS:STATUS, "Done")1 · -
Re: Can I use INDEX/MATCH to reference info on the same sheet?
INDEX/MATCH is good for a single criteria but when you have multiple like you do use INDEX/COLLECT =INDEX(COLLECT(Contact:Contact, Campus:Campus, Campus@row, [Expertise/Role]:[Expertise/Role], ="…1 · -
Re: How can i calculate the % Complete at a sub-parent level based on multiple criteria?
I think what you are asking for is to give the percentage of tasks under a parent that are either P or C. This can be accomplished using the Children formula. =COUNTIF(CHILDREN(Status@row), OR(@cell …1 · -
Re: Issue when Converting to Column Formula - #Invalid Data Type
Add an IFERROR statement to the conversion of the months to numbers. If you have a blank date in your data set that will give you an error which will show up in your Total Charges causing it to also …1 · -
Re: Need to add an "OR" function to my formula
You can nest IF statements together to check for one condition and then the other. =IF([Estimated Project Finish Date]@row > [End Date]@row, 1, IF(AND([End Date]@row <= TODAY(7), [End Date]@row…1 ·
